select * from ms_sizeseq where size_grp = 'F-PANTS'
select * from ms_style where style_no = 'KLAFPT7743'
select * from pos_sku where style_no = 'KLAFPT7743'


select * from pos_sku where style_no = 'KLAFPT7743'

select * from pur_dtl where style_no = 'KLAFPT7743'
select * from pur_size where pur_id = 2422

begin tran
declare @upd_id int
select @upd_id = convert(int, var_data) from igs_parm with(updlock) where var_name = 'gv_upd_id'
update ms_style set size_group = 'F-PANTS', upd_id = @upd_id where style_no = 'KLAFPT7743'
update pos_sku set size = case when size = 'S' then '25' else '27' end, upd_id = @upd_id  where style_no = 'KLAFPT7743'
update pur_size set size = case when size = 'S' then '25' else '27' end where pur_id = 2422
select * from pur_size where pur_id = 2422

rollback tran
